home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Gold Medal Software 2
/
Gold Medal Software Volume 2 (Gold Medal) (1994).iso
/
spreads
/
readws20.arj
/
READ_WKS.DOC
< prev
next >
Wrap
Text File
|
1993-08-08
|
21KB
|
489 lines
Read_WKS, copyright 1991-93 Mountain Software
Read_WKS
(Read Worksheet)
Data Extraction Utility for Lotus and Excel files
Version 2.0
August 8, 1993
_______
____|__ | (R)
--| | |-------------------
| ____|__ | Association of
| | |_| Shareware
|__| o | Professionals
-----| | |---------------------
|___|___| MEMBER
Autodesk Registered Application Developer
Novell Professional Developer
Jerry Workman, P.E.
1579 Nottingham Road
Charleston, WV 25314
CIS 70717,3564
Internet 70717.3564@compuserve.com
Orders: 1-800-2424-PsL
Tech Support: 304-346-9585
FAX 304-744-1785
Read_WKS Documentation page 2
=================================================================
Table of Contents
I. U s i n g R e a d _ W K S . . . . . . . . . . . . . . 3
Purpose . . . . . . . . . . . . . . . . . . . . . . . . 3
Installation . . . . . . . . . . . . . . . . . . . . . . 3
Running Read_WKS . . . . . . . . . . . . . . . . . . . . 3
Limits . . . . . . . . . . . . . . . . . . . . . . . . . 4
Uses and Suggestions . . . . . . . . . . . . . . . . . . 4
II. A d d e n d u m . . . . . . . . . . . . . . . . . . . . 5
Error Messages . . . . . . . . . . . . . . . . . . . . . 5
Liability . . . . . . . . . . . . . . . . . . . . . . . 6
Author . . . . . . . . . . . . . . . . . . . . . . . . . 6
III. L i c e n s e . . . . . . . . . . . . . . . . . . . . . 6
Registration Information . . . . . . . . . . . . . . . . 7
Definition of Shareware . . . . . . . . . . . . . . . . 7
Disclaimer - Agreement . . . . . . . . . . . . . . . . . 8
Trademark . . . . . . . . . . . . . . . . . . . . . . . 9
IV. I n d e x . . . . . . . . . . . . . . . . . . . . . . . 10
Read_WKS Documentation page 3
=================================================================
I. U s i n g R e a d _ W K S
================================
Purpose
-------
Read_WKS is a very powerful program which is used to extract data
from Lotus and Excel files. The data can be formatted in CDF
(comma delimited) format, fixed format, and AutoCAD AutoLISP
format, for use by other programs, or for reporting purposes.
Read_WKS works alone, it is not an add-in to Lotus nor does it
require a "print to disk" from Lotus.
Read_WKS reads Lotus .WKS, WK1, WK3, and WRK files as well as
Excel XLS files directly. The program reads not only the data
(values and labels) from the spreadsheet file, but also cal-
culated formula values. Formatting information; Column widths,
cell formats (eg fixed, comma, $, etc), and cell alignments
(left, right, center), are also read and can be used in format-
ting the extracted data. Read_WKS works on IBM PC compatible
computers running DOS 3.0 or higher with at least 150K of
available memory.
Installation
------------
READ_WKS.EXE can be copied to any directory that is on the DOS
PATH and requires no special installation.
Running Read_WKS
----------------
Read_WKS operated from the DOS command line using switches and
parameters to control it's operations. The switches / commands /
functions are as follows:
Usage: READ_WKS <switches> <filename>.WK1 <outfilename>
The .WK1 extension is assumed and added to <filename> if omitted.
Use the WK3 or XLS extension to read from those respective files.
<outfilename> can also be CON, PRN, STDOUT or any DOS device.
Switches must start with / or - and are not case sensitive but
must be placed before any file name(s).
/D Debug diagnostic display
/R___ Worksheet Range or range name[default A1..D25]
(eg /RB11..F35 or /RTOTALS),
or "*" for the entire worksheet (/R*)
/A AutoCAD LISP output (default output filename is
ACAD.123)
Read_WKS Documentation page 4
=================================================================
/E AppEnd output to the output file
/I Ignore repeating label cells (eg \=)
/U Unformatted (maximum precision) output
/X eXpanded formatted report output, no delimiter, fully
formatted
/S_ Separator / Delimiter character(s) (eg /S;)
/Q Quiet, no display except errors
/P Password program - register Read_WKS
/H Help - This message.
Example: READ_WKS /RC19..F35 MYFILE.WK3 MYFILE.PRN
Or: READ_WKS /A /R* MYFILE
Read_WKS will then execute and will prompt for any missing
parameters:
Enter worksheet filename:
Enter any valid DOS filename including
Drive:\path\filename.ext. If no file extension is specified
then ".WK1" is appended. If you are reading from a WKS or
WRK file then you must enter the full filename.
Enter worksheet range, range name, "*" for all cells
or ? to list defined ranges[default A1..D25]:
Enter either a worksheet range in the usual form
(eg BA34..CL63), or any range name defined in the worksheet.
You may enter a question mark "?" to list all range names in
the selected worksheet file. Enter an asterisk "*" to
specify the entire worksheet.
Limits
------
Read_WKS can not read Lotus SQZ files or Excel Workbooks. If you
use a different spreadsheet program (eg Quattro) then save your
file as a .WK1, WK3, or .XLS file, most spreadsheets (and many
other programs) can save in these file formats.
Read_WKS can not recalculate your spreadsheet. If you use manual
recalculation then be sure to recalculate prior to saving so that
formula values will be correctly displayed.
Uses and Suggestions
--------------------
You can use your favorite spreadsheet program as a data entry
form, and later extract that data for use in other programs, or
for consolidation using Read_WKS.
Read_WKS Documentation page 5
=================================================================
You can use a simple batch file (see the file LOOP.BAT) to "loop"
through a group of files (perhaps all files in a directory)
extracting a range of values from each. Using the /E switch
Read_WKS will place all of this data into a single file. You can
then "import" this file containing consolidated data from many
(perhaps hundreds) of files into your spreadsheet or database.
If you wish to use Read_WKS with AutoCAD, an additional AutoLISP
program (TAB123.LSP) is available to create tables within
AutoCAD. You can obtain -=Tab123=- from the ACAD forum on Com-
puserve, many BBS's, or from Mountain Software directly.
II. A d d e n d u m
====================
Error Messages
--------------
Unidentified file format
The file signature does not match a known file type.
Cannot open file XXXX
Reason: Misspelled filename or possible disk error.
Unknown switch => X <=
An unknown DOS command line switch was passed to
READ_WKS.EXE.
Out of memory
READ_WKS requires about 120K to run.
Unidentified Cell. OpCode = XXh Length = XX
Usually caused by processing a spreadsheet file format not
known by READ_WKS.EXE.
Unexpected end of input file
The end of the file was reached before the end of file
record was read.
Error reading input file
Error writing to output file
A disk error during a read or write operation occurred.
Read_WKS Documentation page 6
=================================================================
Liability
---------
Careful testing has been made to ensure that these programs
perform correctly. No liabilities are assumed in the use or
misuse of this program resulting in data loss or damage. It is
the users responsibility to be sure that the results are as
expected.
Author
------
If you have any suggestions or comments, please contact me.
Jerry Workman, PE
1579 Nottingham Rd.
Charleston, WV 25314
CIS 70717,3564
Internet 70717.3564@compuserve.com
Orders: 1-800-2424-PsL
Tech Support: 304-346-9585
FAX 304-744-1785
Copyright 1991-93 by Mountain Software All rights reserved
III. L i c e n s e
==================
Shareware
---------
This version of Read_WKS is NOT public domain or free software,
but is being distributed as "shareware". You may try it out to
see if it is useful for you. If you wish to continue to use
Read_WKS you must register. Registered users are provided with a
password to remove the opening delay and with support for one
year.
The program in the form of the original archived file only may be
freely distributed, but not sold (except under license, or for a
nominal copying or disk fee).
Non-registered users of this software are granted a limited 30
day license to make an evaluation copy for trial use for the
purpose of determining whether Read_WKS is suitable for their
needs. At the end of this trial period, you may either register
your copy, or discontinue using Read_WKS.
All users are granted a limited license to copy Read_WKS only for
the trial use of others and subject to the above limitations.
Read_WKS Documentation page 7
=================================================================
This license does NOT include distribution or copying of this
software for use:
1. In connection with any other product or service.
2. For general use within a company or institution.
3. For distribution in modified form; i.e., the file containing
this license information MUST be included, along with the
full Read_WKS documentation.
Operators of electronic bulletin board systems (Sysops) are
encouraged to post Read_WKSxx.ZIP for downloading by their users,
as long as these conditions are met.
Registration Information
------------------------
A Read_WKS registration licenses you to use the product on a
regular basis. Individual license cost for Read_WKS is $30 which
includes a diskette with the latest version of Read_WKS and the
printed manual. West Virginia residents should include 6% sales
tax. The file ORDER.DOC contains an order form and additional
ordering information.
Educational institutions, full-time students and BBS sysops can
apply a 50% discount. PLEASE include your educational institution
letterhead (with your title), or a photocopy of your most recent
registration slip, or the name and number of your BBS.
Definition of Shareware
-----------------------
Shareware distribution gives users a chance to try software
before buying it. If you try a Shareware program and continue
using it, you are expected to register. Individual programs
differ on details -- some request registration while others
require it, some specify a maximum trial period. With
registration, you get anything from the simple right to continue
using the software to an updated program with printed manual.
Copyright laws apply to both Shareware and commercial software,
and the copyright holder retains all rights, with a few specific
exceptions as stated below. Shareware authors are accomplished
programmers, just like commercial authors, and the programs are
of comparable quality. (In both cases, there are good programs
and bad ones!) The main difference is in the method of
distribution. The author specifically grants the right to copy
and distribute the software, either to all and sundry or to a
specific group. For example, some authors require written permis-
sion before a commercial disk vendor may copy their Shareware.
Read_WKS Documentation page 8
=================================================================
Shareware is a distribution method, not a type of software. You
should find software that suits your needs and pocketbook,
whether it's commercial or Shareware. The Shareware system makes
fitting your needs easier, because you can try before you buy.
And because the overhead is low, prices are low also. Shareware
has the ultimate money-back guarantee -- if you don't use the
product, you don't pay for it.
Disclaimer - Agreement
----------------------
Users of Read_WKS must accept this disclaimer of warranty:
"Read_WKS is supplied as is. The author disclaims all warran-
ties, expressed or implied, including, without limitation, the
warranties of merchantability and of fitness for any purpose. The
author assumes no liability for damages, direct or consequential,
which may result from the use of Read_WKS."
Read_WKS is a "shareware program" and is provided at no charge to
the user for evaluation. Feel free to share it with your
friends, but please do not give it away altered or as part of
another system. The essence of "user-supported" software is to
provide personal computer users with quality software without
high prices, and yet to provide incentive for programmers to
continue to develop new products. If you find this program
useful and find that you are using Read_WKS and continue to use
Read_WKS after a reasonable trial period, you must make a
registration payment of $30 to Mountain Software. The $30
registration fee will license one copy for use on any one com-
puter at any one time. You must treat this software just like a
book. An example is that this software may be used by any number
of people and may be freely moved from one computer location to
another, so long as there is no possibility of it being used at
one location while it's being used at another. Just as a book
cannot be read by two different persons at the same time.
Commercial users of Read_WKS must register and pay for their
copies of Read_WKS within 30 days of first use or their license
is withdrawn. Site-License arrangements may be made by contac-
ting Mountain Software.
Anyone distributing Read_WKS for any kind of remuneration must
first contact Mountain Software at the address below for
authorization. This authorization will be automatically granted
to distributors recognized by the (ASP) as adhering to its
guidelines for shareware distributors, and such distributors may
begin offering Read_WKS immediately (However Mountain Software
must still be advised so that the distributor can be kept
up-to-date with the latest version of Read_WKS.).
Read_WKS Documentation page 9
=================================================================
You are encouraged to pass a copy of Read_WKS along to your
friends for evaluation. Please encourage them to register their
copy if they find that they can use it.
Jerry Workman a member of the Association of Shareware Profes-
sionals (ASP). ASP wants to make sure that the shareware prin-
ciple works for you. If you are unable to resolve a shareware-
related problem with an ASP member by contacting the member
directly, ASP may be able to help. The ASP Ombudsman can help you
resolve a dispute or problem with an ASP member, but does not
provide technical support for members' products. Please write to
the ASP Ombudsman at 545 Grover Road, Muskegon MI 49442, or send
a message via Compuserve mail to ASP Ombudsman 70007,3536
Trademark
---------
Mountain Software and Read_WKS are trademarks of Mountain
Software. MS-DOS is a registered trademark of Microsoft Cor-
poration. PC-DOS is a registered trademark of IBM Corporation.
AutoCAD is a registered trademark of AutoDesk. 123 and Symphony
are registered trademarks of Lotus Development Corporation
Read_WKS Documentation page 10
=================================================================
IV. I n d e x
123 . . . . . . . . . . . . . . . . . . . . . . . 3, 9
ACAD . . . . . . . . . . . . . . . . . . . . . . 3, 5
ASP . . . . . . . . . . . . . . . . . . . . . . . 8, 9
AutoCAD . . . . . . . . . . . . . . . . . . . . 3, 5, 9
Command . . . . . . . . . . . . . . . . . . . . . 3, 5
Compuserve . . . . . . . . . . . . . . . . 1, 5, 6, 9
directory . . . . . . . . . . . . . . . . . . . . 3, 5
disk . . . . . . . . . . . . . . . . . . . . . 3, 5-7
DOS . . . . . . . . . . . . . . . . . . . . . . 3-5, 9
error . . . . . . . . . . . . . . . . . . . . . . . . 5
Excel . . . . . . . . . . . . . . . . . . . . . 1, 3, 4
file . . . . . . . . . . . . . . . . . . . . . . . 3-7
filename . . . . . . . . . . . . . . . . . . . . . 3-5
license . . . . . . . . . . . . . . . . . . . . . . 6-8
LISP . . . . . . . . . . . . . . . . . . . . . . . . 3
Lotus . . . . . . . . . . . . . . . . . . . 1, 3, 4, 9
range . . . . . . . . . . . . . . . . . . . . . . . 3-5
range name . . . . . . . . . . . . . . . . . . . . . 4
shareware . . . . . . . . . . . . . . . . . . . 1, 6-9
table . . . . . . . . . . . . . . . . . . . . . . . . 2
worksheet . . . . . . . . . . . . . . . . . . . 1, 3, 4
ZIP . . . . . . . . . . . . . . . . . . . . . . . . . 7